﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SMEs360CustomerDegreeDataSet" targetNamespace="http://tempuri.org/SMEs360CustomerDegreeDataSet.xsd" xmlns:mstns="http://tempuri.org/SMEs360CustomerDegreeDataSet.xsd" xmlns="http://tempuri.org/SMEs360CustomerDegreeDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SMEs360CustomerDegreeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SMEs360CustomerDegreeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ClassLibrary1.Properties.Settings.GlobalReference.Default.SMEs360CustomerDegreeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_BRANCHTableAdapter" GeneratorDataComponentClassName="TBL_BRANCHTableAdapter" Name="TBL_BRANCH" UserDataComponentName="TBL_BRANCHTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SMEs360CustomerDegreeConnectionString (Settings)" DbObjectName="SMEs360CustomerDegree.dbo.TBL_BRANCH" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TBL_BRANCH] ([BRANCH_ID], [BRANCH_CODE_SME], [BRANCH_NAME_SME], [REGION], [CITY]) VALUES (@BRANCH_ID, @BRANCH_CODE_SME, @BRANCH_NAME_SME, @REGION, @CITY)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BRANCH_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BRANCH_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BRANCH_CODE_SME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BRANCH_CODE_SME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BRANCH_NAME_SME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BRANCH_NAME_SME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@REGION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="REGION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CITY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CITY" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BRANCH_ID, BRANCH_CODE_SME, BRANCH_NAME_SME, REGION, CITY FROM dbo.TBL_BRANCH</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BRANCH_ID" DataSetColumn="BRANCH_ID" />
              <Mapping SourceColumn="BRANCH_CODE_SME" DataSetColumn="BRANCH_CODE_SME" />
              <Mapping SourceColumn="BRANCH_NAME_SME" DataSetColumn="BRANCH_NAME_SME" />
              <Mapping SourceColumn="REGION" DataSetColumn="REGION" />
              <Mapping SourceColumn="CITY" DataSetColumn="CITY" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_CUSTOMERTableAdapter" GeneratorDataComponentClassName="TBL_CUSTOMERTableAdapter" Name="TBL_CUSTOMER" UserDataComponentName="TBL_CUSTOMERTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SMEs360CustomerDegreeConnectionString (Settings)" DbObjectName="SMEs360CustomerDegree.dbo.TBL_CUSTOMER" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TBL_CUSTOMER] ([BUSINESS_DATE], [CIF], [CUS_NAME], [BRANCH_ID], [ADDRESS], [PROVINCE_CITY], [CUS_OPEN_DATE], [BIRTH_INCORP_DATE], [LEGAL_ID], [TAX_CODE], [VPB_INDUSTRY], [INDUSTRY_NAME], [DOANH_THU], [VIP_CODE], [EMAIL_ADDR], [SEGMENT], [DAO], [PROMOTION_PRG], [SECTOR], [CUST_TYPE], [CUST_TYPE_NAME], [INDUSTRY_NAME_EN], [SUB_SEGMENT], [dao_name], [cus_status], [business_status]) VALUES (@BUSINESS_DATE, @CIF, @CUS_NAME, @BRANCH_ID, @ADDRESS, @PROVINCE_CITY, @CUS_OPEN_DATE, @BIRTH_INCORP_DATE, @LEGAL_ID, @TAX_CODE, @VPB_INDUSTRY, @INDUSTRY_NAME, @DOANH_THU, @VIP_CODE, @EMAIL_ADDR, @SEGMENT, @DAO, @PROMOTION_PRG, @SECTOR, @CUST_TYPE, @CUST_TYPE_NAME, @INDUSTRY_NAME_EN, @SUB_SEGMENT, @dao_name, @cus_status, @business_status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUSINESS_DATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUSINESS_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CIF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CIF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CUS_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CUS_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BRANCH_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BRANCH_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ADDRESS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ADDRESS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PROVINCE_CITY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PROVINCE_CITY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUS_OPEN_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUS_OPEN_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@BIRTH_INCORP_DATE" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="BIRTH_INCORP_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LEGAL_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LEGAL_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TAX_CODE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TAX_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VPB_INDUSTRY" Precision="15" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="VPB_INDUSTRY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INDUSTRY_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INDUSTRY_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DOANH_THU" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DOANH_THU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VIP_CODE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VIP_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EMAIL_ADDR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EMAIL_ADDR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SEGMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SEGMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DAO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PROMOTION_PRG" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PROMOTION_PRG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SECTOR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SECTOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CUST_TYPE" Precision="15" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CUST_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CUST_TYPE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CUST_TYPE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INDUSTRY_NAME_EN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INDUSTRY_NAME_EN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SUB_SEGMENT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SUB_SEGMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dao_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dao_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cus_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cus_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@business_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="business_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BUSINESS_DATE, CIF, CUS_NAME, BRANCH_ID, ADDRESS, PROVINCE_CITY, CUS_OPEN_DATE, BIRTH_INCORP_DATE, LEGAL_ID, TAX_CODE, VPB_INDUSTRY, INDUSTRY_NAME, DOANH_THU, VIP_CODE, EMAIL_ADDR, SEGMENT, DAO, PROMOTION_PRG, SECTOR, CUST_TYPE, CUST_TYPE_NAME, INDUSTRY_NAME_EN, SUB_SEGMENT, dao_name, cus_status, business_status FROM dbo.TBL_CUSTOMER</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BUSINESS_DATE" DataSetColumn="BUSINESS_DATE" />
              <Mapping SourceColumn="CIF" DataSetColumn="CIF" />
              <Mapping SourceColumn="CUS_NAME" DataSetColumn="CUS_NAME" />
              <Mapping SourceColumn="BRANCH_ID" DataSetColumn="BRANCH_ID" />
              <Mapping SourceColumn="ADDRESS" DataSetColumn="ADDRESS" />
              <Mapping SourceColumn="PROVINCE_CITY" DataSetColumn="PROVINCE_CITY" />
              <Mapping SourceColumn="CUS_OPEN_DATE" DataSetColumn="CUS_OPEN_DATE" />
              <Mapping SourceColumn="BIRTH_INCORP_DATE" DataSetColumn="BIRTH_INCORP_DATE" />
              <Mapping SourceColumn="LEGAL_ID" DataSetColumn="LEGAL_ID" />
              <Mapping SourceColumn="TAX_CODE" DataSetColumn="TAX_CODE" />
              <Mapping SourceColumn="VPB_INDUSTRY" DataSetColumn="VPB_INDUSTRY" />
              <Mapping SourceColumn="INDUSTRY_NAME" DataSetColumn="INDUSTRY_NAME" />
              <Mapping SourceColumn="DOANH_THU" DataSetColumn="DOANH_THU" />
              <Mapping SourceColumn="VIP_CODE" DataSetColumn="VIP_CODE" />
              <Mapping SourceColumn="EMAIL_ADDR" DataSetColumn="EMAIL_ADDR" />
              <Mapping SourceColumn="SEGMENT" DataSetColumn="SEGMENT" />
              <Mapping SourceColumn="DAO" DataSetColumn="DAO" />
              <Mapping SourceColumn="PROMOTION_PRG" DataSetColumn="PROMOTION_PRG" />
              <Mapping SourceColumn="SECTOR" DataSetColumn="SECTOR" />
              <Mapping SourceColumn="CUST_TYPE" DataSetColumn="CUST_TYPE" />
              <Mapping SourceColumn="CUST_TYPE_NAME" DataSetColumn="CUST_TYPE_NAME" />
              <Mapping SourceColumn="INDUSTRY_NAME_EN" DataSetColumn="INDUSTRY_NAME_EN" />
              <Mapping SourceColumn="SUB_SEGMENT" DataSetColumn="SUB_SEGMENT" />
              <Mapping SourceColumn="dao_name" DataSetColumn="dao_name" />
              <Mapping SourceColumn="cus_status" DataSetColumn="cus_status" />
              <Mapping SourceColumn="business_status" DataSetColumn="business_status" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SMEs360CustomerDegreeDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SMEs360CustomerDegreeDataSet" msprop:Generator_UserDSName="SMEs360CustomerDegreeDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="TBL_BRANCH" msprop:Generator_TableClassName="TBL_BRANCHDataTable" msprop:Generator_TableVarName="tableTBL_BRANCH" msprop:Generator_TablePropName="TBL_BRANCH" msprop:Generator_RowDeletingName="TBL_BRANCHRowDeleting" msprop:Generator_RowChangingName="TBL_BRANCHRowChanging" msprop:Generator_RowEvHandlerName="TBL_BRANCHRowChangeEventHandler" msprop:Generator_RowDeletedName="TBL_BRANCHRowDeleted" msprop:Generator_UserTableName="TBL_BRANCH" msprop:Generator_RowChangedName="TBL_BRANCHRowChanged" msprop:Generator_RowEvArgName="TBL_BRANCHRowChangeEvent" msprop:Generator_RowClassName="TBL_BRANCHRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BRANCH_ID" msprop:Generator_ColumnVarNameInTable="columnBRANCH_ID" msprop:Generator_ColumnPropNameInRow="BRANCH_ID" msprop:Generator_ColumnPropNameInTable="BRANCH_IDColumn" msprop:Generator_UserColumnName="BRANCH_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BRANCH_CODE_SME" msprop:Generator_ColumnVarNameInTable="columnBRANCH_CODE_SME" msprop:Generator_ColumnPropNameInRow="BRANCH_CODE_SME" msprop:Generator_ColumnPropNameInTable="BRANCH_CODE_SMEColumn" msprop:Generator_UserColumnName="BRANCH_CODE_SME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BRANCH_NAME_SME" msprop:Generator_ColumnVarNameInTable="columnBRANCH_NAME_SME" msprop:Generator_ColumnPropNameInRow="BRANCH_NAME_SME" msprop:Generator_ColumnPropNameInTable="BRANCH_NAME_SMEColumn" msprop:Generator_UserColumnName="BRANCH_NAME_SME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REGION" msprop:Generator_ColumnVarNameInTable="columnREGION" msprop:Generator_ColumnPropNameInRow="REGION" msprop:Generator_ColumnPropNameInTable="REGIONColumn" msprop:Generator_UserColumnName="REGION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CITY" msprop:Generator_ColumnVarNameInTable="columnCITY" msprop:Generator_ColumnPropNameInRow="CITY" msprop:Generator_ColumnPropNameInTable="CITYColumn" msprop:Generator_UserColumnName="CITY" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_CUSTOMER" msprop:Generator_TableClassName="TBL_CUSTOMERDataTable" msprop:Generator_TableVarName="tableTBL_CUSTOMER" msprop:Generator_TablePropName="TBL_CUSTOMER" msprop:Generator_RowDeletingName="TBL_CUSTOMERRowDeleting" msprop:Generator_RowChangingName="TBL_CUSTOMERRowChanging" msprop:Generator_RowEvHandlerName="TBL_CUSTOMERRowChangeEventHandler" msprop:Generator_RowDeletedName="TBL_CUSTOMERRowDeleted" msprop:Generator_UserTableName="TBL_CUSTOMER" msprop:Generator_RowChangedName="TBL_CUSTOMERRowChanged" msprop:Generator_RowEvArgName="TBL_CUSTOMERRowChangeEvent" msprop:Generator_RowClassName="TBL_CUSTOMERRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BUSINESS_DATE" msprop:Generator_ColumnVarNameInTable="columnBUSINESS_DATE" msprop:Generator_ColumnPropNameInRow="BUSINESS_DATE" msprop:Generator_ColumnPropNameInTable="BUSINESS_DATEColumn" msprop:Generator_UserColumnName="BUSINESS_DATE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CIF" msprop:Generator_ColumnVarNameInTable="columnCIF" msprop:Generator_ColumnPropNameInRow="CIF" msprop:Generator_ColumnPropNameInTable="CIFColumn" msprop:Generator_UserColumnName="CIF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUS_NAME" msprop:Generator_ColumnVarNameInTable="columnCUS_NAME" msprop:Generator_ColumnPropNameInRow="CUS_NAME" msprop:Generator_ColumnPropNameInTable="CUS_NAMEColumn" msprop:Generator_UserColumnName="CUS_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BRANCH_ID" msprop:Generator_ColumnVarNameInTable="columnBRANCH_ID" msprop:Generator_ColumnPropNameInRow="BRANCH_ID" msprop:Generator_ColumnPropNameInTable="BRANCH_IDColumn" msprop:Generator_UserColumnName="BRANCH_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ADDRESS" msprop:Generator_ColumnVarNameInTable="columnADDRESS" msprop:Generator_ColumnPropNameInRow="ADDRESS" msprop:Generator_ColumnPropNameInTable="ADDRESSColumn" msprop:Generator_UserColumnName="ADDRESS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PROVINCE_CITY" msprop:Generator_ColumnVarNameInTable="columnPROVINCE_CITY" msprop:Generator_ColumnPropNameInRow="PROVINCE_CITY" msprop:Generator_ColumnPropNameInTable="PROVINCE_CITYColumn" msprop:Generator_UserColumnName="PROVINCE_CITY" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUS_OPEN_DATE" msprop:Generator_ColumnVarNameInTable="columnCUS_OPEN_DATE" msprop:Generator_ColumnPropNameInRow="CUS_OPEN_DATE" msprop:Generator_ColumnPropNameInTable="CUS_OPEN_DATEColumn" msprop:Generator_UserColumnName="CUS_OPEN_DATE" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BIRTH_INCORP_DATE" msprop:Generator_ColumnVarNameInTable="columnBIRTH_INCORP_DATE" msprop:Generator_ColumnPropNameInRow="BIRTH_INCORP_DATE" msprop:Generator_ColumnPropNameInTable="BIRTH_INCORP_DATEColumn" msprop:Generator_UserColumnName="BIRTH_INCORP_DATE" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LEGAL_ID" msprop:Generator_ColumnVarNameInTable="columnLEGAL_ID" msprop:Generator_ColumnPropNameInRow="LEGAL_ID" msprop:Generator_ColumnPropNameInTable="LEGAL_IDColumn" msprop:Generator_UserColumnName="LEGAL_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TAX_CODE" msprop:Generator_ColumnVarNameInTable="columnTAX_CODE" msprop:Generator_ColumnPropNameInRow="TAX_CODE" msprop:Generator_ColumnPropNameInTable="TAX_CODEColumn" msprop:Generator_UserColumnName="TAX_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VPB_INDUSTRY" msprop:Generator_ColumnVarNameInTable="columnVPB_INDUSTRY" msprop:Generator_ColumnPropNameInRow="VPB_INDUSTRY" msprop:Generator_ColumnPropNameInTable="VPB_INDUSTRYColumn" msprop:Generator_UserColumnName="VPB_INDUSTRY" type="xs:decimal" minOccurs="0" />
              <xs:element name="INDUSTRY_NAME" msprop:Generator_ColumnVarNameInTable="columnINDUSTRY_NAME" msprop:Generator_ColumnPropNameInRow="INDUSTRY_NAME" msprop:Generator_ColumnPropNameInTable="INDUSTRY_NAMEColumn" msprop:Generator_UserColumnName="INDUSTRY_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOANH_THU" msprop:Generator_ColumnVarNameInTable="columnDOANH_THU" msprop:Generator_ColumnPropNameInRow="DOANH_THU" msprop:Generator_ColumnPropNameInTable="DOANH_THUColumn" msprop:Generator_UserColumnName="DOANH_THU" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VIP_CODE" msprop:Generator_ColumnVarNameInTable="columnVIP_CODE" msprop:Generator_ColumnPropNameInRow="VIP_CODE" msprop:Generator_ColumnPropNameInTable="VIP_CODEColumn" msprop:Generator_UserColumnName="VIP_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMAIL_ADDR" msprop:Generator_ColumnVarNameInTable="columnEMAIL_ADDR" msprop:Generator_ColumnPropNameInRow="EMAIL_ADDR" msprop:Generator_ColumnPropNameInTable="EMAIL_ADDRColumn" msprop:Generator_UserColumnName="EMAIL_ADDR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SEGMENT" msprop:Generator_ColumnVarNameInTable="columnSEGMENT" msprop:Generator_ColumnPropNameInRow="SEGMENT" msprop:Generator_ColumnPropNameInTable="SEGMENTColumn" msprop:Generator_UserColumnName="SEGMENT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="13" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DAO" msprop:Generator_ColumnVarNameInTable="columnDAO" msprop:Generator_ColumnPropNameInRow="DAO" msprop:Generator_ColumnPropNameInTable="DAOColumn" msprop:Generator_UserColumnName="DAO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PROMOTION_PRG" msprop:Generator_ColumnVarNameInTable="columnPROMOTION_PRG" msprop:Generator_ColumnPropNameInRow="PROMOTION_PRG" msprop:Generator_ColumnPropNameInTable="PROMOTION_PRGColumn" msprop:Generator_UserColumnName="PROMOTION_PRG" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SECTOR" msprop:Generator_ColumnVarNameInTable="columnSECTOR" msprop:Generator_ColumnPropNameInRow="SECTOR" msprop:Generator_ColumnPropNameInTable="SECTORColumn" msprop:Generator_UserColumnName="SECTOR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUST_TYPE" msprop:Generator_ColumnVarNameInTable="columnCUST_TYPE" msprop:Generator_ColumnPropNameInRow="CUST_TYPE" msprop:Generator_ColumnPropNameInTable="CUST_TYPEColumn" msprop:Generator_UserColumnName="CUST_TYPE" type="xs:decimal" minOccurs="0" />
              <xs:element name="CUST_TYPE_NAME" msprop:Generator_ColumnVarNameInTable="columnCUST_TYPE_NAME" msprop:Generator_ColumnPropNameInRow="CUST_TYPE_NAME" msprop:Generator_ColumnPropNameInTable="CUST_TYPE_NAMEColumn" msprop:Generator_UserColumnName="CUST_TYPE_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="INDUSTRY_NAME_EN" msprop:Generator_ColumnVarNameInTable="columnINDUSTRY_NAME_EN" msprop:Generator_ColumnPropNameInRow="INDUSTRY_NAME_EN" msprop:Generator_ColumnPropNameInTable="INDUSTRY_NAME_ENColumn" msprop:Generator_UserColumnName="INDUSTRY_NAME_EN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUB_SEGMENT" msprop:Generator_ColumnVarNameInTable="columnSUB_SEGMENT" msprop:Generator_ColumnPropNameInRow="SUB_SEGMENT" msprop:Generator_ColumnPropNameInTable="SUB_SEGMENTColumn" msprop:Generator_UserColumnName="SUB_SEGMENT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dao_name" msprop:Generator_ColumnVarNameInTable="columndao_name" msprop:Generator_ColumnPropNameInRow="dao_name" msprop:Generator_ColumnPropNameInTable="dao_nameColumn" msprop:Generator_UserColumnName="dao_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cus_status" msprop:Generator_ColumnVarNameInTable="columncus_status" msprop:Generator_ColumnPropNameInRow="cus_status" msprop:Generator_ColumnPropNameInTable="cus_statusColumn" msprop:Generator_UserColumnName="cus_status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="business_status" msprop:Generator_ColumnVarNameInTable="columnbusiness_status" msprop:Generator_ColumnPropNameInRow="business_status" msprop:Generator_ColumnPropNameInTable="business_statusColumn" msprop:Generator_UserColumnName="business_status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>